﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace QuanLyThuNgan
{
    public class FeentDAO
    {
        public string m_Insert_(string sobn, string loaidvu, string dvucode, string DonViTinh, float slg, decimal ThanhTien, decimal dongia, string dvt, int stt, decimal giabhyt,bool NoTronGoi)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_Feent_Insert '{0}','{1}','{2}',N'{3}',{4},{5},{6},'{7}',{8},{9},{10}", sobn, loaidvu, dvucode, DonViTinh, slg, ThanhTien, dongia, dvt, stt, giabhyt,NoTronGoi==false ? 0:1);
            return _sql;
        }
        public string m_Delete_(string sobn, string dvucode)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_Feent_Delete '{0}','{1}'", sobn, dvucode);
            return _sql;
        }
        public string m_Update_(string sobn, string loaidvu, string dvucode, string DonViTinh, float slg, decimal ThanhTien, decimal dongia, string dvt, int stt, decimal giabhyt, bool NoTronGoi)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_Feent_Update '{0}','{1}','{2}',N'{3}',{4},{5},{6},'{7}',{8},{9},{10}", sobn, loaidvu, dvucode, DonViTinh, slg, ThanhTien, dongia, dvt, stt, giabhyt, NoTronGoi == false ? 0 : 1);
            return _sql;
        }
    }
}
